﻿<List Title="CommissionPID" Url="Lists/CommissionPID" BaseType="0" Type="100" Name="CommissionPID"
      DisableAttachments="TRUE" FolderCreation="FALSE" VersioningEnabled="FALSE" EnableContentTypes="TRUE"
      xmlns="http://schemas.microsoft.com/sharepoint/">
  <MetaData>
    <ContentTypes>
      <ContentType ID="0x01003b7743e4960c4618865f01f122aeb500"
               Name="ConsolidationTool_CommissionPID"
               Group="ConsolidationTool"
               Description="Custom Content Type">
        <FieldRefs>
          <FieldRef Name="Title" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E690}"/>
          <FieldRef Name="LinkTitle" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E691}"/>
          
          <FieldRef Name="Region" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E693}"/>
          <FieldRef Name="SubRegion" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E694}"/>
          <FieldRef Name="Entity" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E695}"/>
          <FieldRef Name="Qty_YTDLM" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E696}"/>
          <FieldRef Name="InvoiceCurrency_YTDLM" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E697}"/>
          <FieldRef Name="InvoiceAmount_YTDLM" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E698}"/>
          <FieldRef Name="BookAmount_YTDLM" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E699}"/>
          <FieldRef Name="Qty" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E700}"/>
          <FieldRef Name="InvoiceCurrency" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E701}"/>
          <FieldRef Name="InvoiceAmount" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E702}"/>
          <FieldRef Name="BookAmount" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E703}"/>
          <FieldRef Name="EntityData" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E706}"/>

          <FieldRef Name="Year" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E704}"/>
          <FieldRef Name="Month" ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E705}"/>
        </FieldRefs>

      </ContentType>
    </ContentTypes>

    <Fields>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E690}" Type="Text"  DisplayName="Title"  Name="Title"   StaticName="Title" Required="TRUE"   Indexed="TRUE" EnforceUniqueValues="true" />
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E691}" Type="Computed"  DisplayName="Title" Name="LinkTitle"  StaticName="LinkTitle" ReadOnly="TRUE"></Field>
      
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E693}" Type="Lookup" List="Lists/Region"  DisplayName="Region" ShowField="Title" Name="Region"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E694}" Type="Lookup" List="Lists/SubRegion"  ShowField="Title"  DisplayName="SubRegion"  Name="SubRegion"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E695}" Type="Lookup" List="Lists/Entity" DisplayName="Entity"  Name="Entity"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E696}" Type="Number" DisplayName="Qty YTD M-1" Name ="Qty_YTDLM" />
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E697}" Type="Number" DisplayName="Invoice Currency YTD M-1" Name ="InvoiceCurrency_YTDLM"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E698}" Type="Number" DisplayName ="Invoice Amount YTD M-1" Name="InvoiceAmount_YTDLM"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E699}" Type="Number" DisplayName ="Book Amount YTD M-1" Name="BookAmount_YTDLM"/>

      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E700}" Type="Number" DisplayName="Qty" Name ="Qty" />
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E701}" Type="Number" DisplayName="Invoice Currency" Name ="InvoiceCurrency"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E702}" Type="Number" DisplayName ="Invoice Amount" Name="InvoiceAmount"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E703}" Type="Number" DisplayName ="Book Amount" Name="BookAmount"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E706}" Type="Lookup" List="Lists/Entity" ShowField ="Title" DisplayName ="EntityData" Name="EntityData"/>

      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E704}" Type="Integer" DisplayName="Year" Name="Year"/>
      <Field ID="{CD74A73F-97A8-4A4B-9786-E6364EA8E705}" Type="Integer" DisplayName="Month" Name="Month"/>
    </Fields>
    <Forms>
      <Form Type="DisplayForm" Url="DispForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="EditForm" Url="EditForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
      <Form Type="NewForm" Url="NewForm.aspx"
            SetupPath="pages\form.aspx" WebPartZoneID="Main" />
    </Forms>

    <Views>
      <View DisplayName="All Items" DefaultView="TRUE" BaseViewID="1" Type="HTML"
            WebPartZoneID="Main" WebPartOrder="1" Url="AllItems.aspx" SetupPath="pages\viewpage.aspx" >
        <XslLink>main.xsl</XslLink>
        <ViewFields>
          <FieldRef Name="LinkTitle"/>
          <FieldRef Name="ParentForm"/>
          <FieldRef Name="Region"/>
          <FieldRef Name="SubRegion"/>
          <FieldRef Name="Entity"/>
          <FieldRef Name ="Qty" />
          <FieldRef Name ="InvoiceCurrency" />
          <FieldRef Name ="InvoiceAmount" />
          <FieldRef Name ="BookAmount" />
        </ViewFields>
        <RowLimit Paged="TRUE">30</RowLimit>
      </View>
    </Views>
  </MetaData>
</List>
